SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{8ef6e2466989e975017c86f7ce5b6347675eaaba0410fba6fd473354c3638414}Cancelada{8ef6e2466989e975017c86f7ce5b6347675eaaba0410fba6fd473354c3638414}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{8ef6e2466989e975017c86f7ce5b6347675eaaba0410fba6fd473354c3638414}Cancelada{8ef6e2466989e975017c86f7ce5b6347675eaaba0410fba6fd473354c3638414}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{8ef6e2466989e975017c86f7ce5b6347675eaaba0410fba6fd473354c3638414}Spain{8ef6e2466989e975017c86f7ce5b6347675eaaba0410fba6fd473354c3638414}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{8ef6e2466989e975017c86f7ce5b6347675eaaba0410fba6fd473354c3638414}Spain{8ef6e2466989e975017c86f7ce5b6347675eaaba0410fba6fd473354c3638414}' OR prCountry = 'Spain')